﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_Collect') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_Collect
END
GO
create view V_Collect
as select 
A.[Guid]
,A.[MemLoginID]
,A.[ProductGuid]
,A.[CollectTime]
,B.[SmallImage]
,B.[ShopPrice]
,B.[Name]
from [ShopNum1_Collect] A 
JOIN [ShopNum1_Product] B
ON(A.[ProductGuid]=B.[Guid])